Moving Network SQL Projects

Geoscience > Additional Resources > Project Management > Moving and Deleting Projects > Moving Network SQL Projects

Moving SeisWare Projects with Microsoft® SQL Databases Stored on the Network

Whether you are moving a project from a local SQL Server or from a network SQL Server to a network SQL Server, there are two techniques. Because the database isn't stored in the project folder when you have a network installation of SQL Server, you can't simply move the project folder to a new location. You need to convert the project to Microsoft SQL LocalDB to make it portable, or you need to create a new project and copy all of the data, and then delete the original project.

Convert the SQL project to LocalDB, move the project, and convert the project to SQL
Create a new SQL project, use Copy Project Data to populate the new project, then delete the original project

Convert SQL Project to LocalDB

You will be required to have SQL Server 2016 Express LocalDB installed on your machine for this technique to work.

From the Main Launcher's Project menu select Convert Database.
Select the project and then change the To Database Type to "SQL LocalDB".
Click Convert.
Follow the instructions for moving projects with LocalDB databases.
Once the project has been moved, From the Main Launcher's Project menu select Convert Database.
Select the project and convert it to SQL ensuring that you select the correct Server Name.

Create a New SQL Project

Create a new, blank SQL project in the correct location and using the correct SQL Server Name.
From the Main launcher's Project menu select Copy Project Data.
Use the Copy Project Data utility to copy the project data using the original project as the Source and the new project as the Destination.
Delete the original project.

Also See

— MORE INFORMATION